package com.qf.dao;

import com.qf.pojo.entity.StoreGoodsClassify;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.transaction.annotation.Transactional;

/**
 * @ClassName StoreGoodsClassifyRepository
 * @Description TODO
 * @Author Windy
 * @Date 2022/10/5 16:28
 * @Version 1.0
 **/
public interface StoreGoodsClassifyRepository extends JpaRepository<StoreGoodsClassify,Integer> {
    @Query(value = "delete from store_goods_classify where goods_classify_id=?1 and store_id=?2",nativeQuery = true)
    @Modifying
    @Transactional
    void deleteByClassifyIdAndStoreId(int id, int storeId);
}
